/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-25 10:51:09
*/


-- ----------------------------
-- Table structure for tb0106
-- ----------------------------
DROP TABLE [dbo].[tb0106]
GO
CREATE TABLE [dbo].[tb0106] (
[WareHouseID] varchar(20) NOT NULL ,
[TranMonth] int NOT NULL ,
[TranYear] int NOT NULL ,
[DivisionID] varchar(20) NOT NULL ,
[InventoryID] varchar(20) NOT NULL ,
[InventoryAccountID] varchar(50) NOT NULL ,
[BeginQuantity] money NULL ,
[EndQuantity] money NULL ,
[DebitQuantity] money NULL ,
[CreditQuantity] money NULL ,
[InDebitQuantity] money NULL ,
[InCreditQuantity] money NULL ,
[BeginAmount] money NULL ,
[EndAmount] money NULL ,
[DebitAmount] money NULL ,
[CreditAmount] money NULL ,
[InDebitAmount] money NULL ,
[InCreditAmount] money NULL ,
[UnitPrice] money NULL 
)


GO

-- ----------------------------
-- Indexes structure for table tb0106
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb0106
-- ----------------------------
ALTER TABLE [dbo].[tb0106] ADD PRIMARY KEY NONCLUSTERED ([WareHouseID], [TranMonth], [TranYear], [DivisionID], [InventoryID], [InventoryAccountID])
GO
